package com.dy.nygl.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import com.dy.nygl.pojo.Alerts;

@Component("alertsDAO")
public interface AlertsMapper {
	public void addAlerts(Alerts alerts);
	public List<Alerts> getAlertsByTypeId(@Param("typeId")int typeId);
	public List<Alerts> getAlertsAllList();
	
	public int getAlertSituationCount();
	public List<Map<String, Object>> getAlertSituation(@Param("begin")int begin ,@Param("rowsPage")int rowsPage);
	
	public int getAlertsCount();
	public List<Alerts> getAlertsByPages(@Param("begin")int begin ,@Param("rowsPage")int rowsPage);
	
	public int getUnAlertsCount();
	public List<Alerts> getUnAlertsByPages(@Param("begin")int begin ,@Param("rowsPage")int rowsPage);
	
	public void updateAlertsStatus(@Param("id")int id);
	public void deleteAlerts(@Param("id")int id);
}
